class AddColumnSecondToCdrRaws < ActiveRecord::Migration
  def self.up
    add_column :cdr_raws, :c1_start_time, :string
    add_column :cdr_raws, :c2_start_time, :string
    add_column :cdr_raws, :c3_call_duration, :string
    add_column :cdr_raws, :c4_call_source, :string
    add_column :cdr_raws, :c5_call_source_q931sig_port, :string
    add_column :cdr_raws, :c6_call_dest, :string
    add_column :cdr_raws, :c7_field_unused, :string
    add_column :cdr_raws, :c8_call_source_custid, :string
    add_column :cdr_raws, :c9_called_party_on_dest__CALL_TO_, :string
    add_column :cdr_raws, :c10_called_party_from_src, :string
    add_column :cdr_raws, :c11_call_type, :string
    add_column :cdr_raws, :c12_field_unused, :string
    add_column :cdr_raws, :c13_disconnect_error_type, :string
    add_column :cdr_raws, :c14_call_error, :string
    add_column :cdr_raws, :c15_call_error, :string
    add_column :cdr_raws, :c16_field_unused, :string
    add_column :cdr_raws, :c17_field_unused, :string
    add_column :cdr_raws, :c18_ani__CALLING_FROM_, :string
    add_column :cdr_raws, :c19_field_unused, :string
    add_column :cdr_raws, :c20_field_unused, :string
    add_column :cdr_raws, :c21_field_unused, :string
    add_column :cdr_raws, :c22_cdr_seq_no, :string
    add_column :cdr_raws, :c23_field_unused, :string
    add_column :cdr_raws, :c24_callid, :string
    add_column :cdr_raws, :c25_call_hold_time, :string
    add_column :cdr_raws, :c26_call_source_regid, :string
    add_column :cdr_raws, :c27_call_source_uport, :string
    add_column :cdr_raws, :c28_call_dest_regid, :string
    add_column :cdr_raws, :c29_call_dest_uport, :string
    add_column :cdr_raws, :c30_isdn_cause_code, :string
    add_column :cdr_raws, :c31_called_party_after_src_calling_plan, :string
    add_column :cdr_raws, :c32_call_error_dest, :string
    add_column :cdr_raws, :c33_call_error_dest, :string
    add_column :cdr_raws, :c34_call_error_event_str, :string
    add_column :cdr_raws, :c35_new_ani, :string
    add_column :cdr_raws, :c36_call_duration, :string
    add_column :cdr_raws, :c37_incoming_leg_callid, :string
    add_column :cdr_raws, :c38_protocol, :string
    add_column :cdr_raws, :c39_cdr_type, :string
    add_column :cdr_raws, :c40_hunting_attempts, :string
    add_column :cdr_raws, :c41_caller_trunk_group, :string
    add_column :cdr_raws, :c42_call_pdd, :string
    add_column :cdr_raws, :c43_h323_dest_ras_error, :string
    add_column :cdr_raws, :c44_h323_dest_h225_error, :string
    add_column :cdr_raws, :c45_sip_dest_respcode, :string
    add_column :cdr_raws, :c46_dest_trunk_group, :string
    add_column :cdr_raws, :c47_call_duration_fractional, :string
    add_column :cdr_raws, :c48_timezone, :string
    add_column :cdr_raws, :c49_msw_name, :string
    add_column :cdr_raws, :c50_called_party_after_transit_route, :string
    add_column :cdr_raws, :c51_called_party_on_dest_num_type, :string
    add_column :cdr_raws, :c52_called_party_from_src_num_type, :string
    add_column :cdr_raws, :c53_call_source_realm_name, :string
    add_column :cdr_raws, :c54_call_dest_realm_name, :string
    add_column :cdr_raws, :c55_call_dest_crname, :string
    add_column :cdr_raws, :c56_call_dest_custid, :string
    add_column :cdr_raws, :c57_call_zone_data, :string
    add_column :cdr_raws, :c58_calling_party_on_dest_num_type, :string
    add_column :cdr_raws, :c59_calling_party_from_src_num_type, :string
    add_column :cdr_raws, :c60_original_isdn_cause_code, :string
    add_column :cdr_raws, :c61_packets_received_on_src_leg, :string
    add_column :cdr_raws, :c62_packets_lost_on_src_leg, :string
    add_column :cdr_raws, :c63_packets_discarded_on_src_leg, :string
    add_column :cdr_raws, :c64_pdv_on_src_leg, :string
    add_column :cdr_raws, :c65_codec_on_src_leg, :string
    add_column :cdr_raws, :c66_latency_on_src_leg, :string
    add_column :cdr_raws, :c67_rfactor_on_src_leg, :string
    add_column :cdr_raws, :c68_packets_received_on_dest_leg, :string
    add_column :cdr_raws, :c69_packets_lost_on_dest_leg, :string
    add_column :cdr_raws, :c70_packets_discarded_on_dest_leg, :string
    add_column :cdr_raws, :c71_pdv_on_dest_leg, :string
    add_column :cdr_raws, :c72_codec_on_dest_leg, :string
    add_column :cdr_raws, :c73_latency_on_dest_leg, :string
    add_column :cdr_raws, :c74_rfactor_on_dest_leg, :string
    add_column :cdr_raws, :c75_sip_src_respcode, :string
    add_column :cdr_raws, :c76_peer_protocol, :string
    add_column :cdr_raws, :c77_src_private_ip, :string
    add_column :cdr_raws, :c78_dest_private_ip, :string
    add_column :cdr_raws, :c79_src_igrp_name, :string
    add_column :cdr_raws, :c80_dest_igrp_name, :string
    add_column :cdr_raws, :c81_, :integer
    add_column :cdr_raws, :c82_, :integer
    add_column :cdr_raws, :c83_, :integer
    add_column :cdr_raws, :c84_, :integer
    add_column :cdr_raws, :c85_, :integer
    add_column :cdr_raws, :c86_WHO_DISCONNECTED, :string
    add_column :cdr_raws, :c87_, :integer
    add_column :cdr_raws, :c88_, :integer
    add_column :cdr_raws, :c89_, :integer
    add_column :cdr_raws, :c90_, :integer
    add_column :cdr_raws, :c91_, :integer
    add_column :cdr_raws, :c92_, :integer
    add_column :cdr_raws, :c93_, :integer
    add_column :cdr_raws, :c94_, :integer
    add_column :cdr_raws, :c95_, :integer
    add_column :cdr_raws, :c96_, :integer
    add_column :cdr_raws, :c97_, :integer
    add_column :cdr_raws, :c98_, :integer
    add_column :cdr_raws, :c99_, :integer
  end

  def self.down
    remove_column :cdr_raws, :c99_
    remove_column :cdr_raws, :c98_
    remove_column :cdr_raws, :c97_
    remove_column :cdr_raws, :c96_
    remove_column :cdr_raws, :c95_
    remove_column :cdr_raws, :c94_
    remove_column :cdr_raws, :c93_
    remove_column :cdr_raws, :c92_
    remove_column :cdr_raws, :c91_
    remove_column :cdr_raws, :c90_
    remove_column :cdr_raws, :c89_
    remove_column :cdr_raws, :c88_
    remove_column :cdr_raws, :c87_
    remove_column :cdr_raws, :c86_WHO_DISCONNECTED
    remove_column :cdr_raws, :c85_
    remove_column :cdr_raws, :c84_
    remove_column :cdr_raws, :c83_
    remove_column :cdr_raws, :c82_
    remove_column :cdr_raws, :c81_
    remove_column :cdr_raws, :c80_dest_igrp_name
    remove_column :cdr_raws, :c79_src_igrp_name
    remove_column :cdr_raws, :c78_dest_private_ip
    remove_column :cdr_raws, :c77_src_private_ip
    remove_column :cdr_raws, :c76_peer_protocol
    remove_column :cdr_raws, :c75_sip_src_respcode
    remove_column :cdr_raws, :c74_rfactor_on_dest_leg
    remove_column :cdr_raws, :c73_latency_on_dest_leg
    remove_column :cdr_raws, :c72_codec_on_dest_leg
    remove_column :cdr_raws, :c71_pdv_on_dest_leg
    remove_column :cdr_raws, :c70_packets_discarded_on_dest_leg
    remove_column :cdr_raws, :c69_packets_lost_on_dest_leg
    remove_column :cdr_raws, :c68_packets_received_on_dest_leg
    remove_column :cdr_raws, :c67_rfactor_on_src_leg
    remove_column :cdr_raws, :c66_latency_on_src_leg
    remove_column :cdr_raws, :c65_codec_on_src_leg
    remove_column :cdr_raws, :c64_pdv_on_src_leg
    remove_column :cdr_raws, :c63_packets_discarded_on_src_leg
    remove_column :cdr_raws, :c62_packets_lost_on_src_leg
    remove_column :cdr_raws, :c61_packets_received_on_src_leg
    remove_column :cdr_raws, :c60_original_isdn_cause_code
    remove_column :cdr_raws, :c59_calling_party_from_src_num_type
    remove_column :cdr_raws, :c58_calling_party_on_dest_num_type
    remove_column :cdr_raws, :c57_call_zone_data
    remove_column :cdr_raws, :c56_call_dest_custid
    remove_column :cdr_raws, :c55_call_dest_crname
    remove_column :cdr_raws, :c54_call_dest_realm_name
    remove_column :cdr_raws, :c53_call_source_realm_name
    remove_column :cdr_raws, :c52_called_party_from_src_num_type
    remove_column :cdr_raws, :c51_called_party_on_dest_num_type
    remove_column :cdr_raws, :c50_called_party_after_transit_route
    remove_column :cdr_raws, :c49_msw_name
    remove_column :cdr_raws, :c48_timezone
    remove_column :cdr_raws, :c47_call_duration_fractional
    remove_column :cdr_raws, :c46_dest_trunk_group
    remove_column :cdr_raws, :c45_sip_dest_respcode
    remove_column :cdr_raws, :c44_h323_dest_h225_error
    remove_column :cdr_raws, :c43_h323_dest_ras_error
    remove_column :cdr_raws, :c42_call_pdd
    remove_column :cdr_raws, :c41_caller_trunk_group
    remove_column :cdr_raws, :c40_hunting_attempts
    remove_column :cdr_raws, :c39_cdr_type
    remove_column :cdr_raws, :c38_protocol
    remove_column :cdr_raws, :c37_incoming_leg_callid
    remove_column :cdr_raws, :c36_call_duration
    remove_column :cdr_raws, :c35_new_ani
    remove_column :cdr_raws, :c34_call_error_event_str
    remove_column :cdr_raws, :c33_call_error_dest
    remove_column :cdr_raws, :c32_call_error_dest
    remove_column :cdr_raws, :c31_called_party_after_src_calling_plan
    remove_column :cdr_raws, :c30_isdn_cause_code
    remove_column :cdr_raws, :c29_call_dest_uport
    remove_column :cdr_raws, :c28_call_dest_regid
    remove_column :cdr_raws, :c27_call_source_uport
    remove_column :cdr_raws, :c26_call_source_regid
    remove_column :cdr_raws, :c25_call_hold_time
    remove_column :cdr_raws, :c24_callid
    remove_column :cdr_raws, :c23_field_unused
    remove_column :cdr_raws, :c22_cdr_seq_no
    remove_column :cdr_raws, :c21_field_unused
    remove_column :cdr_raws, :c20_field_unused
    remove_column :cdr_raws, :c19_field_unused
    remove_column :cdr_raws, :c18_ani__CALLING_FROM_
    remove_column :cdr_raws, :c17_field_unused
    remove_column :cdr_raws, :c16_field_unused
    remove_column :cdr_raws, :c15_call_error
    remove_column :cdr_raws, :c14_call_error
    remove_column :cdr_raws, :c13_disconnect_error_type
    remove_column :cdr_raws, :c12_field_unused
    remove_column :cdr_raws, :c11_call_type
    remove_column :cdr_raws, :c10_called_party_from_src
    remove_column :cdr_raws, :c9_called_party_on_dest__CALL_TO_
    remove_column :cdr_raws, :c8_call_source_custid
    remove_column :cdr_raws, :c7_field_unused
    remove_column :cdr_raws, :c6_call_dest
    remove_column :cdr_raws, :c5_call_source_q931sig_port
    remove_column :cdr_raws, :c4_call_source
    remove_column :cdr_raws, :c3_call_duration
    remove_column :cdr_raws, :c2_start_time
    remove_column :cdr_raws, :c1_start_time
  end
end
